Pandas Profiling Report

Dataset info

Number of variables	51
Number of observations	462298
Missing cells	2183512 (9.3%)
Duplicate rows	0 (0.0%)
Total size in memory	179.9 MiB
Average record size in memory	408.0 B

Variables types

Numeric	12
Categorical	17
Boolean	15
Date	0
URL	0
Text (Unique)	1
Rejected	6
Unsupported	0

Warnings

`de_faixa_faturamento_estimado` has 27513 (6.0%) missing values	Missing
`de_faixa_faturamento_estimado_grupo` has 27513 (6.0%) missing values	Missing
`de_natureza_juridica` has a high cardinality: 67 distinct values	Warning
`de_nivel_atividade` has 11168 (2.4%) missing values	Missing
`de_saude_rescencia` has 14851 (3.2%) missing values	Missing
`de_saude_tributaria` has 14851 (3.2%) missing values	Missing
`dt_situacao` has a high cardinality: 7335 distinct values	Warning
`empsetorcensitariofaixarendapopulacao` has 143829 (31.1%) missing values	Missing
`fl_optante_simei` is highly correlated with `fl_mei` (ρ = 0.9579210437)	Rejected
`fl_optante_simples` has 82713 (17.9%) missing values	Missing
`idade_maxima_socios` has 151602 (32.8%) missing values	Missing
`idade_media_socios` is highly correlated with `idade_maxima_socios` (ρ = 0.9568741341)	Rejected
`idade_minima_socios` is highly correlated with `idade_media_socios` (ρ = 0.9533591208)	Rejected
`nm_divisao` has a high cardinality: 88 distinct values	Warning
`nm_meso_regiao` has 58698 (12.7%) missing values	Missing
`nm_micro_regiao` has a high cardinality: 74 distinct values	Warning
`nm_micro_regiao` has 58698 (12.7%) missing values	Missing
`nu_meses_rescencia` has 45276 (9.8%) missing values	Missing
`qt_filiais` has 418043 (90.4%) zeros	Zeros
`qt_socios` is highly skewed (γ1 = 27.25083606)	Skewed
`qt_socios` has 115091 (24.9%) missing values	Missing
`qt_socios_feminino` is highly skewed (γ1 = 76.48075241)	Skewed
`qt_socios_feminino` has 317269 (68.6%) missing values	Missing
`qt_socios_masculino` is highly correlated with `qt_socios` (ρ = 0.9632367436)	Rejected
`qt_socios_pf` is highly correlated with `qt_socios_masculino` (ρ = 0.9652540624)	Rejected
`qt_socios_pj` has 342663 (74.1%) zeros	Zeros
`qt_socios_pj` has 115091 (24.9%) missing values	Missing
`qt_socios_st_regular` is highly correlated with `qt_socios_pf` (ρ = 0.9883617721)	Rejected
`vl_faturamento_estimado_aux` is highly skewed (γ1 = 329.062977)	Skewed
`vl_faturamento_estimado_aux` has 27513 (6.0%) missing values	Missing
`vl_faturamento_estimado_grupo_aux` is highly skewed (γ1 = 26.79710656)	Skewed
`vl_faturamento_estimado_grupo_aux` has 27513 (6.0%) missing values	Missing
`vl_total_veiculos_leves_grupo` is highly skewed (γ1 = 34.48790893)	Skewed
`vl_total_veiculos_leves_grupo` has 424180 (91.8%) zeros	Zeros
`vl_total_veiculos_pesados_grupo` is highly skewed (γ1 = 31.26208196)	Skewed
`vl_total_veiculos_pesados_grupo` has 441360 (95.5%) zeros	Zeros

de_faixa_faturamento_estimado
Categorical

Distinct count	13
Unique (%)	< 0.1%
Missing (%)	6.0%
Missing (n)	27513

DE R$ 81.000,01 A R$ 360.000,00	273861
ATE R$ 81.000,00	98558
DE R$ 360.000,01 A R$ 1.500.000,00	46225
Other values (9)	16141
(Missing)	27513

Toggle details

Common values
Composition

Value	Count	Frequency (%)
DE R$ 81.000,01 A R$ 360.000,00	273861	59.2%
ATE R$ 81.000,00	98558	21.3%
DE R$ 360.000,01 A R$ 1.500.000,00	46225	10.0%
DE R$ 1.500.000,01 A R$ 4.800.000,00	10153	2.2%
DE R$ 4.800.000,01 A R$ 10.000.000,00	2150	0.5%
DE R$ 10.000.000,01 A R$ 30.000.000,00	1445	0.3%
SEM INFORMACAO	1173	0.3%
DE R$ 30.000.000,01 A R$ 100.000.000,00	871	0.2%
DE R$ 100.000.000,01 A R$ 300.000.000,00	253	0.1%
DE R$ 300.000.000,01 A R$ 500.000.000,00	48	< 0.1%
Other values (2)	48	< 0.1%
(Missing)	27513	6.0%

Max length	40
Mean length	26.5734072
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

de_faixa_faturamento_estimado_grupo
Categorical

Distinct count	12
Unique (%)	< 0.1%
Missing (%)	6.0%
Missing (n)	27513

DE R$ 81.000,01 A R$ 360.000,00	252602
ATE R$ 81.000,00	98118
DE R$ 360.000,01 A R$ 1.500.000,00	53492
Other values (8)	30573
(Missing)	27513

Toggle details

Common values
Composition

Value	Count	Frequency (%)
DE R$ 81.000,01 A R$ 360.000,00	252602	54.6%
ATE R$ 81.000,00	98118	21.2%
DE R$ 360.000,01 A R$ 1.500.000,00	53492	11.6%
DE R$ 1.500.000,01 A R$ 4.800.000,00	13465	2.9%
DE R$ 4.800.000,01 A R$ 10.000.000,00	4055	0.9%
ACIMA DE 1 BILHAO DE REAIS	3613	0.8%
DE R$ 10.000.000,01 A R$ 30.000.000,00	3598	0.8%
DE R$ 30.000.000,01 A R$ 100.000.000,00	3061	0.7%
DE R$ 100.000.000,01 A R$ 300.000.000,00	1583	0.3%
DE R$ 500.000.000,01 A 1 BILHAO DE REAIS	676	0.1%
(Missing)	27513	6.0%

Max length	40
Mean length	26.8179248
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

de_natureza_juridica
Categorical

Distinct count	67
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

EMPRESARIO INDIVIDUAL	295756
SOCIEDADE EMPRESARIA LIMITADA	91231
ASSOCIACAO PRIVADA	29694
Other values (64)	45617

Toggle details

Common values
Composition

Value	Count	Frequency (%)
EMPRESARIO INDIVIDUAL	295756	64.0%
SOCIEDADE EMPRESARIA LIMITADA	91231	19.7%
ASSOCIACAO PRIVADA	29694	6.4%
EMPRESA INDIVIDUAL DE RESPONSABILIDADE LIMITADA DE NATUREZA EMPRESARIA	15183	3.3%
ORGAO DE DIRECAO LOCAL DE PARTIDO POLITICO	7301	1.6%
ORGANIZACAO RELIGIOSA	2908	0.6%
SOCIEDADE ANONIMA FECHADA	2196	0.5%
CONDOMINIO EDILICIO	2084	0.5%
ENTIDADE SINDICAL	1763	0.4%
CANDIDATO A CARGO POLITICO ELETIVO	1617	0.3%
Other values (57)	12565	2.7%

Max length	70
Mean length	24.49725069
Min length	9
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

de_nivel_atividade
Categorical

Distinct count	5
Unique (%)	< 0.1%
Missing (%)	2.4%
Missing (n)	11168

MEDIA	217949
ALTA	152245
BAIXA	76080
(Missing)	11168

Toggle details

Common values
Composition

Value	Count	Frequency (%)
MEDIA	217949	47.1%
ALTA	152245	32.9%
BAIXA	76080	16.5%
MUITO BAIXA	4856	1.1%
(Missing)	11168	2.4%

Max length	11
Mean length	4.685386915
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

de_ramo
Categorical

Distinct count	33
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

COMERCIO VAREJISTA	172404
SERVICOS DIVERSOS	60318
SERVICOS DE ALOJAMENTO/ALIMENTACAO	30180
Other values (30)	199396

Toggle details

Common values
Composition

Value	Count	Frequency (%)
COMERCIO VAREJISTA	172404	37.3%
SERVICOS DIVERSOS	60318	13.0%
SERVICOS DE ALOJAMENTO/ALIMENTACAO	30180	6.5%
INDUSTRIA DA CONSTRUCAO	25363	5.5%
COMERCIO E REPARACAO DE VEICULOS	22356	4.8%
SERVICOS ADMINISTRATIVOS	21326	4.6%
BENS DE CONSUMO	21227	4.6%
SERVICOS PROFISSIONAIS, TECNICOS E CIENTIFICOS	17371	3.8%
COMERCIO POR ATACADO	16464	3.6%
TRANSPORTE, ARMAZENAGEM E CORREIO	15485	3.3%
Other values (23)	59804	12.9%

Max length	49
Mean length	22.05983154
Min length	6
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

de_saude_rescencia
Categorical

Distinct count	6
Unique (%)	< 0.1%
Missing (%)	3.2%
Missing (n)	14851

ACIMA DE 1 ANO	378896
ATE 1 ANO	38101
SEM INFORMACAO	30425
Other values (2)	25
(Missing)	14851

Toggle details

Common values
Composition

Value	Count	Frequency (%)
ACIMA DE 1 ANO	378896	82.0%
ATE 1 ANO	38101	8.2%
SEM INFORMACAO	30425	6.6%
ATE 3 MESES	13	< 0.1%
ATE 6 MESES	12	< 0.1%
(Missing)	14851	3.2%

Max length	14
Mean length	13.23438778
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

de_saude_tributaria
Categorical

Distinct count	7
Unique (%)	< 0.1%
Missing (%)	3.2%
Missing (n)	14851

VERDE	145430
AZUL	105230
AMARELO	91045
Other values (3)	105742

Toggle details

Common values
Composition

Value	Count	Frequency (%)
VERDE	145430	31.5%
AZUL	105230	22.8%
AMARELO	91045	19.7%
CINZA	64019	13.8%
LARANJA	36116	7.8%
VERMELHO	5607	1.2%
(Missing)	14851	3.2%

Max length	8
Mean length	5.294638956
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

dt_situacao
Categorical

Distinct count	7335
Unique (%)	1.6%
Missing (%)	< 0.1%
Missing (n)	6

2005-11-03	69465
2006-12-21	2207
2006-12-01	2018
Other values (7331)	388602

Toggle details

Common values
Composition

Value	Count	Frequency (%)
2005-11-03	69465	15.0%
2006-12-21	2207	0.5%
2006-12-01	2018	0.4%
2010-05-15	1799	0.4%
2005-09-24	1523	0.3%
1998-07-28	1490	0.3%
2006-12-02	1436	0.3%
2005-08-27	1391	0.3%
2004-10-30	954	0.2%
2001-07-01	892	0.2%
Other values (7324)	379117	82.0%

Max length	10
Mean length	9.99990915
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

empsetorcensitariofaixarendapopulacao
Numeric

Distinct count	15420
Unique (%)	3.3%
Missing (%)	31.1%
Missing (n)	143829
Infinite (%)	0.0%
Infinite (n)	0

Mean	1308.005725
Minimum	100
Maximum	75093.84
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	100
5-th percentile	424.28
Q1	673.23
Median	946.68
Q3	1518.08
95-th percentile	3516.99
Maximum	75093.84
Range	74993.84
Interquartile range	844.85

Descriptive statistics

Standard deviation	1161.889222
Coef of variation	0.8882906242
Kurtosis	397.288486
Mean	1308.005725
MAD	721.2561603
Skewness	9.232437997
Sum	416559275.1
Variance	1349986.563
Memory size	3.5 MiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1549.1	1995	0.4%
2361.38	830	0.2%
1086.05	729	0.2%
3940.05	536	0.1%
3321.86	536	0.1%
2679.5	529	0.1%
3071.98	479	0.1%
786.74	456	0.1%
1910.81	447	0.1%
2019.39	445	0.1%
Other values (15409)	311487	67.4%
(Missing)	143829	31.1%

Minimum 5 values

Value	Count	Frequency (%)
100	3	< 0.1%
106.67	1	< 0.1%
107.7	1	< 0.1%
110.3	72	< 0.1%
130	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
75093.84	7	< 0.1%
30861.81	22	< 0.1%
15137.49	3	< 0.1%
13793	22	< 0.1%
12512.93	149	< 0.1%

fl_antt
Boolean

Distinct count	3
Unique (%)	< 0.1%
Missing (%)	0.4%
Missing (n)	1927

0	457095
1	3276
(Missing)	1927

Toggle details

Value	Count	Frequency (%)
0	457095	98.9%
1	3276	0.7%
(Missing)	1927	0.4%

fl_email
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

0	256228
1	206070

Toggle details

Value	Count	Frequency (%)
0	256228	55.4%
1	206070	44.6%

fl_ltda
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

0	461056
1	1242

Toggle details

Value	Count	Frequency (%)
0	461056	99.7%
1	1242	0.3%

fl_matriz
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

1	433232
0	29066

Toggle details

Value	Count	Frequency (%)
1	433232	93.7%
0	29066	6.3%

fl_me
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

0	461083
1	1215

Toggle details

Value	Count	Frequency (%)
0	461083	99.7%
1	1215	0.3%

fl_mei
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

0	311398
1	150900

Toggle details

Value	Count	Frequency (%)
0	311398	67.4%
1	150900	32.6%

fl_optante_simei
Highly correlated

This variable is highly correlated with fl_mei and should be ignored for analysis

Correlation	0.9579210437

fl_optante_simples
Boolean

Distinct count	3
Unique (%)	< 0.1%
Missing (%)	17.9%
Missing (n)	82713

1	199617
0	179968
(Missing)	82713

Toggle details

Value	Count	Frequency (%)
1	199617	43.2%
0	179968	38.9%
(Missing)	82713	17.9%

fl_passivel_iss
Boolean

Distinct count	3
Unique (%)	< 0.1%
Missing (%)	0.4%
Missing (n)	1927

1	264741
0	195630
(Missing)	1927

Toggle details

Value	Count	Frequency (%)
1	264741	57.3%
0	195630	42.3%
(Missing)	1927	0.4%

fl_rm
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

0	236779
1	225519

Toggle details

Value	Count	Frequency (%)
0	236779	51.2%
1	225519	48.8%

fl_sa
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

0	453866
1	8432

Toggle details

Value	Count	Frequency (%)
0	453866	98.2%
1	8432	1.8%

fl_simples_irregular
Boolean

Distinct count	3
Unique (%)	< 0.1%
Missing (%)	0.4%
Missing (n)	1927

0	460030
1	341
(Missing)	1927

Toggle details

Value	Count	Frequency (%)
0	460030	99.5%
1	341	0.1%
(Missing)	1927	0.4%

fl_spa
Boolean

Distinct count	3
Unique (%)	< 0.1%
Missing (%)	0.4%
Missing (n)	1927

0	460091
1	280
(Missing)	1927

Toggle details

Value	Count	Frequency (%)
0	460091	99.5%
1	280	0.1%
(Missing)	1927	0.4%

fl_st_especial
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

0	462230
1	68

Toggle details

Value	Count	Frequency (%)
0	462230	> 99.9%
1	68	< 0.1%

fl_telefone
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

1	335468
0	126830

Toggle details

Value	Count	Frequency (%)
1	335468	72.6%
0	126830	27.4%

fl_veiculo
Boolean

Distinct count	3
Unique (%)	< 0.1%
Missing (%)	0.4%
Missing (n)	1927

0	429687
1	30684
(Missing)	1927

Toggle details

Value	Count	Frequency (%)
0	429687	92.9%
1	30684	6.6%
(Missing)	1927	0.4%

id
Categorical, Unique

First 5 values
000001857eec66f7d67ea918825c9980eebff5c10b36f3...
0000133f443484b40bc632e3b8595c8348441b3899973f...
000047a124312a6e977ac8e37c677ae4eed7614d945996...
000061121bf1a98d79c02f156af0cadec80ea1c68236e6...
00009a58c6d16b1439d1918b27734c78283a7264e0ac1e...

Last 5 values
ffff6c0b13631b6bf0dc823675f8f54bf66552b8c87521...
ffff8882a623edc8a4b322217921aad8a3e84efacdaea1...
ffff989f6f3a687bcf883db3de06772544b625dcc29635...
ffff996a58acd0fc5e95b95edc812827b37fff57c3c239...
ffffd4fc4571772f61964cafe6c28a8d1fb8cec9103093...

Toggle details

First 5 values

Value	Count	Frequency (%)
000001857eec66f7d67ea918825c9980eebff5c10b36f3cbcf8b977dae2673f3	1	< 0.1%
0000133f443484b40bc632e3b8595c8348441b3899973f25a5375e915f84ef88	1	< 0.1%
000047a124312a6e977ac8e37c677ae4eed7614d9459968a48875a030c2bb31c	1	< 0.1%
000061121bf1a98d79c02f156af0cadec80ea1c68236e69c8a36d0b087878a78	1	< 0.1%
00009a58c6d16b1439d1918b27734c78283a7264e0ac1ed169baf5304b72f538	1	< 0.1%

Last 5 values

Value	Count	Frequency (%)
ffffd4fc4571772f61964cafe6c28a8d1fb8cec91030934be200aaec2d902161	1	< 0.1%
ffff996a58acd0fc5e95b95edc812827b37fff57c3c239f037cedf6cfb574dfb	1	< 0.1%
ffff989f6f3a687bcf883db3de06772544b625dcc29635ddaf631d7ba3dc6584	1	< 0.1%
ffff8882a623edc8a4b322217921aad8a3e84efacdaea101cfd23bceef91fb5a	1	< 0.1%
ffff6c0b13631b6bf0dc823675f8f54bf66552b8c87521bd419642465b05e304	1	< 0.1%

idade_emp_cat
Categorical

Distinct count	6
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

1 a 5	138580
5 a 10	116100
> 20	75572
Other values (3)	132046

Toggle details

Common values
Composition

Value	Count	Frequency (%)
1 a 5	138580	30.0%
5 a 10	116100	25.1%
> 20	75572	16.3%
10 a 15	49205	10.6%
<= 1	46794	10.1%
15 a 20	36047	7.8%

Max length	7
Mean length	5.355264353
Min length	4
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

idade_empresa_anos
Numeric

Distinct count	14198
Unique (%)	3.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	9.948676561
Minimum	0.01643835616
Maximum	106.4328767
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	0.01643835616
5-th percentile	0.4575342466
Q1	2.756164384
Median	6.704109589
Q3	14.46575342
95-th percentile	30.17808219
Maximum	106.4328767
Range	106.4164384
Interquartile range	11.70958904

Descriptive statistics

Standard deviation	9.615664247
Coef of variation	0.9665269735
Kurtosis	1.52217534
Mean	9.948676561
MAD	7.553130844
Skewness	1.376723032
Sum	4599253.277
Variance	92.46099891
Memory size	3.5 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[1.64383562e-02 2.19178082e-02 2.87671233e-02 3.69863014e-02 4.52054795e-02 ... 5.21219178e+01 5.22917808e+01 5.29986301e+01 5.67438356e+01 1.06432877e+02], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0.2054794521	595	0.1%
0.2082191781	571	0.1%
0.202739726	470	0.1%
0.2164383562	322	0.1%
7.331506849	281	0.1%
0.2219178082	276	0.1%
6.317808219	271	0.1%
3.536986301	260	0.1%
3.534246575	257	0.1%
6.315068493	256	0.1%
Other values (14188)	458739	99.2%

Minimum 5 values

Value	Count	Frequency (%)
0.01643835616	1	< 0.1%
0.02739726027	24	< 0.1%
0.0301369863	179	< 0.1%
0.03287671233	188	< 0.1%
0.03561643836	193	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
106.4328767	1	< 0.1%
89.44383562	1	< 0.1%
80.63835616	1	< 0.1%
77.52876712	1	< 0.1%
75.05479452	1	< 0.1%

idade_maxima_socios
Numeric

Distinct count	119
Unique (%)	< 0.1%
Missing (%)	32.8%
Missing (n)	151602
Infinite (%)	0.0%
Infinite (n)	0

Mean	44.3441306
Minimum	-2
Maximum	127
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	-2
5-th percentile	24
Q1	34
Median	43
Q3	54
95-th percentile	69
Maximum	127
Range	129
Interquartile range	20

Descriptive statistics

Standard deviation	13.93038532
Coef of variation	0.3141427091
Kurtosis	-0.0009405849143
Mean	44.3441306
MAD	11.33842405
Skewness	0.5390117117
Sum	13777544
Variance	194.0556351
Memory size	3.5 MiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
37	8925	1.9%
36	8906	1.9%
39	8721	1.9%
38	8699	1.9%
40	8686	1.9%
41	8591	1.9%
35	8500	1.8%
33	8306	1.8%
34	8095	1.8%
42	8089	1.7%
Other values (108)	225178	48.7%
(Missing)	151602	32.8%

Minimum 5 values

Value	Count	Frequency (%)
-2	1	< 0.1%
3	1	< 0.1%
4	2	< 0.1%
5	3	< 0.1%
6	5	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
127	1	< 0.1%
125	1	< 0.1%
123	1	< 0.1%
121	1	< 0.1%
120	1	< 0.1%

idade_media_socios
Highly correlated

This variable is highly correlated with idade_maxima_socios and should be ignored for analysis

Correlation	0.9568741341

idade_minima_socios
Highly correlated

This variable is highly correlated with idade_media_socios and should be ignored for analysis

Correlation	0.9533591208

natureza_juridica_macro
Categorical

Distinct count	7
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

OUTROS	320211
ENTIDADES EMPRESARIAIS	99241
ENTIDADES SEM FINS LUCRATIVOS	37089
Other values (4)	5757

Toggle details

Common values
Composition

Value	Count	Frequency (%)
OUTROS	320211	69.3%
ENTIDADES EMPRESARIAIS	99241	21.5%
ENTIDADES SEM FINS LUCRATIVOS	37089	8.0%
ADMINISTRACAO PUBLICA	2912	0.6%
CARGO POLITICO	1617	0.3%
PESSOAS FISICAS	1225	0.3%
INSTITUICOES EXTRATERRITORIAIS	3	< 0.1%

Max length	30
Mean length	11.42640461
Min length	6
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

nm_divisao
Categorical

Distinct count	88
Unique (%)	< 0.1%
Missing (%)	0.4%
Missing (n)	1927

COMERCIO VAREJISTA	172404
ATIVIDADES DE ORGANIZACOES ASSOCIATIVAS	37984
ALIMENTACAO	27540
Other values (84)	222443

Toggle details

Common values
Composition

Value	Count	Frequency (%)
COMERCIO VAREJISTA	172404	37.3%
ATIVIDADES DE ORGANIZACOES ASSOCIATIVAS	37984	8.2%
ALIMENTACAO	27540	6.0%
COMERCIO E REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS	22356	4.8%
COMERCIO POR ATACADO EXCETO VEICULOS AUTOMOTORES E MOTOCICLETAS	16464	3.6%
OUTRAS ATIVIDADES DE SERVICOS PESSOAIS	15875	3.4%
SERVICOS ESPECIALIZADOS PARA CONSTRUCAO	14291	3.1%
TRANSPORTE TERRESTRE	11439	2.5%
EDUCACAO	11311	2.4%
SERVICOS DE ESCRITORIO DE APOIO ADMINISTRATIVO E OUTROS SERVICOS PRESTADOS PRINCIPALMENTE AS EMPRESAS	9726	2.1%
Other values (77)	120981	26.2%

Max length	120
Mean length	32.89757905
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

nm_meso_regiao
Categorical

Distinct count	20
Unique (%)	< 0.1%
Missing (%)	12.7%
Missing (n)	58698

CENTRO AMAZONENSE	71469
NORTE MARANHENSE	61331
LESTE POTIGUAR	58762
Other values (16)	212038
(Missing)	58698

Toggle details

Common values
Composition

Value	Count	Frequency (%)
CENTRO AMAZONENSE	71469	15.5%
NORTE MARANHENSE	61331	13.3%
LESTE POTIGUAR	58762	12.7%
CENTRO NORTE PIAUIENSE	42244	9.1%
OESTE MARANHENSE	26796	5.8%
OESTE POTIGUAR	20860	4.5%
LESTE MARANHENSE	17651	3.8%
VALE DO ACRE	16539	3.6%
CENTRO MARANHENSE	13755	3.0%
SUDOESTE PIAUIENSE	12180	2.6%
Other values (9)	62013	13.4%
(Missing)	58698	12.7%

Max length	22
Mean length	14.58877174
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

nm_micro_regiao
Categorical

Distinct count	74
Unique (%)	< 0.1%
Missing (%)	12.7%
Missing (n)	58698

MANAUS	60008
NATAL	46745
AGLOMERACAO URBANA DE SAO LUIS	45875
Other values (70)	250972
(Missing)	58698

Toggle details

Common values
Composition

Value	Count	Frequency (%)
MANAUS	60008	13.0%
NATAL	46745	10.1%
AGLOMERACAO URBANA DE SAO LUIS	45875	9.9%
TERESINA	33887	7.3%
IMPERATRIZ	15912	3.4%
RIO BRANCO	14064	3.0%
MOSSORO	10713	2.3%
PINDARE	8167	1.8%
MACAIBA	7318	1.6%
LITORAL PIAUIENSE	6816	1.5%
Other values (63)	154095	33.3%
(Missing)	58698	12.7%

Max length	33
Mean length	11.08048056
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

nm_segmento
Categorical

Distinct count	22
Unique (%)	< 0.1%
Missing (%)	0.4%
Missing (n)	1927

COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS	211224
OUTRAS ATIVIDADES DE SERVICOS	59561
INDUSTRIAS DE TRANSFORMACAO	31968
Other values (18)	157618

Toggle details

Common values
Composition

Value	Count	Frequency (%)
COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS	211224	45.7%
OUTRAS ATIVIDADES DE SERVICOS	59561	12.9%
INDUSTRIAS DE TRANSFORMACAO	31968	6.9%
ALOJAMENTO E ALIMENTACAO	30180	6.5%
CONSTRUCAO	25363	5.5%
ATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEMENTARES	21326	4.6%
ATIVIDADES PROFISSIONAIS CIENTIFICAS E TECNICAS	17371	3.8%
TRANSPORTE ARMAZENAGEM E CORREIO	15485	3.3%
EDUCACAO	11311	2.4%
SAUDE HUMANA E SERVICOS SOCIAIS	10139	2.2%
Other values (11)	26443	5.7%

Max length	65
Mean length	42.52199447
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

nu_meses_rescencia
Numeric

Distinct count	52
Unique (%)	< 0.1%
Missing (%)	9.8%
Missing (n)	45276
Infinite (%)	0.0%
Infinite (n)	0

Mean	25.00724662
Minimum	0
Maximum	66
Zeros (%)	< 0.1%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	9
Q1	22
Median	23
Q3	25
95-th percentile	48
Maximum	66
Range	66
Interquartile range	3

Descriptive statistics

Standard deviation	9.679799286
Coef of variation	0.3870797707
Kurtosis	1.945603876
Mean	25.00724662
MAD	5.88354324
Skewness	1.261726999
Sum	10428572
Variance	93.69851423
Memory size	3.5 MiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
23	108609	23.5%
22	89143	19.3%
24	44574	9.6%
48	26480	5.7%
25	25087	5.4%
26	24218	5.2%
27	18888	4.1%
21	12154	2.6%
7	10016	2.2%
47	9637	2.1%
Other values (41)	48216	10.4%
(Missing)	45276	9.8%

Minimum 5 values

Value	Count	Frequency (%)
0	4	< 0.1%
1	4	< 0.1%
2	5	< 0.1%
5	8	< 0.1%
6	4	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
66	41	< 0.1%
65	33	< 0.1%
64	4	< 0.1%
54	1560	0.3%
53	51	< 0.1%

qt_filiais
Numeric

Distinct count	304
Unique (%)	0.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	28.73704407
Minimum	0
Maximum	9647
Zeros (%)	90.4%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	2
Maximum	9647
Range	9647
Interquartile range	0

Descriptive statistics

Standard deviation	468.6260942
Coef of variation	16.30738684
Kurtosis	356.9251027
Mean	28.73704407
MAD	56.06139032
Skewness	18.6663858
Sum	13285078
Variance	219610.4161
Memory size	3.5 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[0.0000e+00 5.0000e-01 1.5000e+00 2.5000e+00 3.5000e+00 ... 5.4670e+03 8.4785e+03 9.3405e+03 9.5290e+03 9.6470e+03], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	418043	90.4%
1	19561	4.2%
2	5943	1.3%
3	2884	0.6%
4	1772	0.4%
5	1161	0.3%
6	818	0.2%
7	637	0.1%
8	544	0.1%
9	485	0.1%
Other values (294)	10450	2.3%

Minimum 5 values

Value	Count	Frequency (%)
0	418043	90.4%
1	19561	4.2%
2	5943	1.3%
3	2884	0.6%
4	1772	0.4%

Maximum 5 values

Value	Count	Frequency (%)
9647	265	0.1%
9411	281	0.1%
9270	373	0.1%
7687	191	< 0.1%
5491	106	< 0.1%

qt_socios
Numeric

Distinct count	63
Unique (%)	< 0.1%
Missing (%)	24.9%
Missing (n)	115091
Infinite (%)	0.0%
Infinite (n)	0

Mean	1.496326399
Minimum	1
Maximum	246
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
Median	1
Q3	2
95-th percentile	3
Maximum	246
Range	245
Interquartile range	1

Descriptive statistics

Standard deviation	3.276626415
Coef of variation	2.18978053
Kurtosis	923.2237301
Mean	1.496326399
MAD	0.7386222867
Skewness	27.25083606
Sum	519535
Variance	10.73628066
Memory size	3.5 MiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	258353	55.9%
2	71030	15.4%
3	8902	1.9%
4	3214	0.7%
5	1612	0.3%
6	998	0.2%
8	749	0.2%
7	557	0.1%
9	300	0.1%
96	265	0.1%
Other values (52)	1227	0.3%
(Missing)	115091	24.9%

Minimum 5 values

Value	Count	Frequency (%)
1	258353	55.9%
2	71030	15.4%
3	8902	1.9%
4	3214	0.7%
5	1612	0.3%

Maximum 5 values

Value	Count	Frequency (%)
246	1	< 0.1%
238	1	< 0.1%
199	1	< 0.1%
168	1	< 0.1%
165	1	< 0.1%

qt_socios_feminino
Numeric

Distinct count	34
Unique (%)	< 0.1%
Missing (%)	68.6%
Missing (n)	317269
Infinite (%)	0.0%
Infinite (n)	0

Mean	1.107116508
Minimum	1
Maximum	140
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
Median	1
Q3	1
95-th percentile	2
Maximum	140
Range	139
Interquartile range	0

Descriptive statistics

Standard deviation	0.8401936523
Coef of variation	0.7589026507
Kurtosis	9249.637522
Mean	1.107116508
MAD	0.1980018315
Skewness	76.48075241
Sum	160564
Variance	0.7059253734
Memory size	3.5 MiB

Histogram with fixed size bins (bins=34)

Value	Count	Frequency (%)
1	134041	29.0%
2	9084	2.0%
3	1247	0.3%
4	324	0.1%
5	133	< 0.1%
6	59	< 0.1%
7	30	< 0.1%
15	28	< 0.1%
9	23	< 0.1%
8	16	< 0.1%
Other values (23)	44	< 0.1%
(Missing)	317269	68.6%

Minimum 5 values

Value	Count	Frequency (%)
1	134041	29.0%
2	9084	2.0%
3	1247	0.3%
4	324	0.1%
5	133	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
140	1	< 0.1%
95	1	< 0.1%
93	1	< 0.1%
88	1	< 0.1%
74	1	< 0.1%

qt_socios_masculino
Highly correlated

This variable is highly correlated with qt_socios and should be ignored for analysis

Correlation	0.9632367436

qt_socios_pf
Highly correlated

This variable is highly correlated with qt_socios_masculino and should be ignored for analysis

Correlation	0.9652540624

qt_socios_pj
Numeric

Distinct count	13
Unique (%)	< 0.1%
Missing (%)	24.9%
Missing (n)	115091
Infinite (%)	0.0%
Infinite (n)	0

Mean	0.01964534125
Minimum	0
Maximum	13
Zeros (%)	74.1%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	0
Maximum	13
Range	13
Interquartile range	0

Descriptive statistics

Standard deviation	0.1951660243
Coef of variation	9.934468524
Kurtosis	362.7623512
Mean	0.01964534125
MAD	0.0387764738
Skewness	14.78811156
Sum	6821
Variance	0.03808977704
Memory size	3.5 MiB

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
0	342663	74.1%
1	2783	0.6%
2	1459	0.3%
3	193	< 0.1%
4	70	< 0.1%
5	14	< 0.1%
7	9	< 0.1%
6	6	< 0.1%
8	5	< 0.1%
9	3	< 0.1%
Other values (2)	2	< 0.1%
(Missing)	115091	24.9%

Minimum 5 values

Value	Count	Frequency (%)
0	342663	74.1%
1	2783	0.6%
2	1459	0.3%
3	193	< 0.1%
4	70	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
13	1	< 0.1%
12	1	< 0.1%
9	3	< 0.1%
8	5	< 0.1%
7	9	< 0.1%

qt_socios_st_regular
Highly correlated

This variable is highly correlated with qt_socios_pf and should be ignored for analysis

Correlation	0.9883617721

setor
Categorical

Distinct count	6
Unique (%)	< 0.1%
Missing (%)	0.4%
Missing (n)	1927

COMERCIO	211224
SERVIÇO	189644
INDUSTRIA	30893
Other values (2)	28610

Toggle details

Common values
Composition

Value	Count	Frequency (%)
COMERCIO	211224	45.7%
SERVIÇO	189644	41.0%
INDUSTRIA	30893	6.7%
CONSTRUÇÃO CIVIL	25363	5.5%
AGROPECUARIA	3247	0.7%
(Missing)	1927	0.4%

Max length	16
Mean length	8.102760557
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

sg_uf
Categorical

Distinct count	6
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

MA	127654
RN	98837
AM	82114
Other values (3)	153693

Toggle details

Common values
Composition

Value	Count	Frequency (%)
MA	127654	27.6%
RN	98837	21.4%
AM	82114	17.8%
PI	76686	16.6%
RO	56469	12.2%
AC	20538	4.4%

Max length	2
Mean length	2
Min length	2
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

sg_uf_matriz
Categorical

Distinct count	28
Unique (%)	< 0.1%
Missing (%)	0.4%
Missing (n)	1939

MA	124823
RN	96743
AM	80032
Other values (24)	158761

Toggle details

Common values
Composition

Value	Count	Frequency (%)
MA	124823	27.0%
RN	96743	20.9%
AM	80032	17.3%
PI	75201	16.3%
RO	54876	11.9%
AC	20028	4.3%
SP	2845	0.6%
DF	1225	0.3%
CE	927	0.2%
RJ	669	0.1%
Other values (17)	2990	0.6%
(Missing)	1939	0.4%

Max length	3
Mean length	2.004194264
Min length	2
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

vl_faturamento_estimado_aux
Numeric

Distinct count	1921
Unique (%)	0.4%
Missing (%)	6.0%
Missing (n)	27513
Infinite (%)	0.0%
Infinite (n)	0

Mean	802091.1378
Minimum	0
Maximum	1.4546625e+10
Zeros (%)	0.3%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	50000
Q1	164851.2
Median	210000
Q3	210000
95-th percentile	989107.2
Maximum	1.4546625e+10
Range	1.4546625e+10
Interquartile range	45148.8

Descriptive statistics

Standard deviation	30999788.42
Coef of variation	38.6487108
Kurtosis	137216.1313
Mean	802091.1378
MAD	1119630.467
Skewness	329.062977
Sum	3.487371953e+11
Variance	9.609868822e+14
Memory size	3.5 MiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
210000	249868	54.0%
50000	94137	20.4%
930000	16075	3.5%
185457.6	8252	1.8%
370915.2	6489	1.4%
123638.4	6357	1.4%
247276.8	3920	0.8%
556372.8	2901	0.6%
741830.4	2853	0.6%
61819.2	2162	0.5%
Other values (1910)	41771	9.0%
(Missing)	27513	6.0%

Minimum 5 values

Value	Count	Frequency (%)
0	1173	0.3%
41047.03	1	< 0.1%
41212.8	1923	0.4%
50000	94137	20.4%
51516	335	0.1%

Maximum 5 values

Value	Count	Frequency (%)
1.4546625e+10	1	< 0.1%
9961906000	1	< 0.1%
3490930200	1	< 0.1%
3220831700	1	< 0.1%
2669847000	1	< 0.1%

vl_faturamento_estimado_grupo_aux
Numeric

Distinct count	6795
Unique (%)	1.5%
Missing (%)	6.0%
Missing (n)	27513
Infinite (%)	0.0%
Infinite (n)	0

Mean	336720529.8
Minimum	41047.03
Maximum	2.227618e+11
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	41047.03
5-th percentile	50000
Q1	185457.6
Median	210000
Q3	210000
95-th percentile	2843683.2
Maximum	2.227618e+11
Range	2.22761759e+11
Interquartile range	24542.4

Descriptive statistics

Standard deviation	7114614457
Coef of variation	21.12913775
Kurtosis	756.5828773
Mean	336720529.8
MAD	662945084.1
Skewness	26.79710656
Sum	1.464010356e+14
Variance	5.061773887e+19
Memory size	3.5 MiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
210000	230845	49.9%
50000	94137	20.4%
930000	12789	2.8%
185457.6	7149	1.5%
420000	6916	1.5%
123638.4	5696	1.2%
370915.2	5573	1.2%
247276.8	3415	0.7%
741830.4	2396	0.5%
556372.8	2391	0.5%
Other values (6784)	63478	13.7%
(Missing)	27513	6.0%

Minimum 5 values

Value	Count	Frequency (%)
41047.03	1	< 0.1%
41212.8	1774	0.4%
50000	94137	20.4%
51516	308	0.1%
61819.2	1898	0.4%

Maximum 5 values

Value	Count	Frequency (%)
2.227618e+11	191	< 0.1%
1.8943014e+11	265	0.1%
1.8120853e+11	26	< 0.1%
1.2398112e+11	9	< 0.1%
1.009873e+11	15	< 0.1%

vl_total_veiculos_leves_grupo
Numeric

Distinct count	311
Unique (%)	0.1%
Missing (%)	0.4%
Missing (n)	1927
Infinite (%)	0.0%
Infinite (n)	0

Mean	48.6991774
Minimum	0
Maximum	122090
Zeros (%)	91.8%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	1
Maximum	122090
Range	122090
Interquartile range	0

Descriptive statistics

Standard deviation	1206.696804
Coef of variation	24.77858699
Kurtosis	1614.685275
Mean	48.6991774
MAD	95.963728
Skewness	34.48790893
Sum	22419689
Variance	1456117.176
Memory size	3.5 MiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	424180	91.8%
1	15738	3.4%
2	5232	1.1%
3	2610	0.6%
4	1569	0.3%
5	1099	0.2%
6	781	0.2%
7	618	0.1%
8	512	0.1%
10	408	0.1%
Other values (300)	7624	1.6%
(Missing)	1927	0.4%

Minimum 5 values

Value	Count	Frequency (%)
0	424180	91.8%
1	15738	3.4%
2	5232	1.1%
3	2610	0.6%
4	1569	0.3%

Maximum 5 values

Value	Count	Frequency (%)
122090	2	< 0.1%
105312	2	< 0.1%
96763	2	< 0.1%
57941	2	< 0.1%
44250	1	< 0.1%

vl_total_veiculos_pesados_grupo
Numeric

Distinct count	297
Unique (%)	0.1%
Missing (%)	0.4%
Missing (n)	1927
Infinite (%)	0.0%
Infinite (n)	0

Mean	3.591800961
Minimum	0
Maximum	9782
Zeros (%)	95.5%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	0
Maximum	9782
Range	9782
Interquartile range	0

Descriptive statistics

Standard deviation	72.60035227
Coef of variation	20.21279939
Kurtosis	1491.122182
Mean	3.591800961
MAD	6.98457279
Skewness	31.26208196
Sum	1653561
Variance	5270.81115
Memory size	3.5 MiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	441360	95.5%
1	6785	1.5%
2	2585	0.6%
3	1301	0.3%
4	827	0.2%
5	653	0.1%
7	532	0.1%
6	487	0.1%
1177	373	0.1%
95	283	0.1%
Other values (286)	5185	1.1%
(Missing)	1927	0.4%

Minimum 5 values

Value	Count	Frequency (%)
0	441360	95.5%
1	6785	1.5%
2	2585	0.6%
3	1301	0.3%
4	827	0.2%

Maximum 5 values

Value	Count	Frequency (%)
9782	1	< 0.1%
3674	2	< 0.1%
3484	1	< 0.1%
2710	2	< 0.1%
2693	5	< 0.1%

First rows

	de_faixa_faturamento_estimado	de_faixa_faturamento_estimado_grupo	de_natureza_juridica	de_nivel_atividade	de_ramo	de_saude_rescencia	de_saude_tributaria	dt_situacao	empsetorcensitariofaixarendapopulacao	fl_email	fl_matriz	fl_mei	fl_optante_simei	fl_optante_simples	fl_passivel_iss	fl_rm	fl_telefone	id	idade_emp_cat	idade_empresa_anos	idade_maxima_socios	idade_media_socios	idade_minima_socios	natureza_juridica_macro	nm_divisao	nm_meso_regiao	nm_micro_regiao	nm_segmento	nu_meses_rescencia	qt_filiais	qt_socios	qt_socios_feminino	qt_socios_masculino	qt_socios_pf	qt_socios_pj	qt_socios_st_regular	setor	sg_uf	sg_uf_matriz	vl_faturamento_estimado_aux	vl_faturamento_estimado_grupo_aux
0	DE R$ 1.500.000,01 A R$ 4.800.000,00	DE R$ 1.500.000,01 A R$ 4.800.000,00	SOCIEDADE EMPRESARIA LIMITADA	ALTA	INDUSTRIA DA CONSTRUCAO	ACIMA DE 1 ANO	VERDE	2005-03-25	NaN	1	1	0	0.0	1.0	1.0	1	1	a6984c3ae395090e3bee8ad63c3758b110de096d5d8195...	10 a 15	14.457534	47.0	44.0	41.0	ENTIDADES EMPRESARIAIS	CONSTRUCAO DE EDIFICIOS	LESTE POTIGUAR	NATAL	CONSTRUCAO	23.0	0	2.0	NaN	2.0	2.0	0.0	2.0	CONSTRUÇÃO CIVIL	RN	RN	3132172.8	3132172.8
1	DE R$ 81.000,01 A R$ 360.000,00	DE R$ 81.000,01 A R$ 360.000,00	EMPRESARIO INDIVIDUAL	BAIXA	SERVICOS DE ALOJAMENTO/ALIMENTACAO	ATE 1 ANO	CINZA	2017-05-12	468.93	1	1	1	NaN	NaN	1.0	1	1	6178f41ade1365e44bc2c46654c2c8c0eaae27dcb476c4...	1 a 5	1.463014	27.0	27.0	27.0	OUTROS	ALIMENTACAO	CENTRO NORTE PIAUIENSE	TERESINA	ALOJAMENTO E ALIMENTACAO	9.0	0	1.0	NaN	1.0	1.0	0.0	1.0	SERVIÇO	PI	PI	210000.0	210000.0
2	ATE R$ 81.000,00	ATE R$ 81.000,00	EMPRESARIO INDIVIDUAL	MEDIA	TRANSPORTE, ARMAZENAGEM E CORREIO	ACIMA DE 1 ANO	AMARELO	2011-09-26	713.50	0	1	1	1.0	1.0	1.0	1	1	4a7e5069a397f12fdd7fd57111d6dc5d3ba558958efc02...	5 a 10	7.093151	32.0	32.0	32.0	OUTROS	TRANSPORTE TERRESTRE	CENTRO AMAZONENSE	MANAUS	TRANSPORTE ARMAZENAGEM E CORREIO	26.0	0	1.0	NaN	1.0	1.0	0.0	NaN	SERVIÇO	AM	AM	50000.0	50000.0
3	DE R$ 81.000,01 A R$ 360.000,00	DE R$ 81.000,01 A R$ 360.000,00	EMPRESARIO INDIVIDUAL	MEDIA	SERVICOS DIVERSOS	ACIMA DE 1 ANO	AMARELO	2012-04-25	475.73	1	1	0	0.0	1.0	1.0	1	1	3348900fe63216a439d2e5238c79ddd46ede454df7b9d8...	5 a 10	6.512329	36.0	36.0	36.0	OUTROS	REPARACAO E MANUTENCAO DE EQUIPAMENTOS DE INFO...	CENTRO AMAZONENSE	MANAUS	OUTRAS ATIVIDADES DE SERVICOS	26.0	0	1.0	NaN	1.0	1.0	0.0	1.0	SERVIÇO	AM	AM	210000.0	210000.0
4	DE R$ 81.000,01 A R$ 360.000,00	DE R$ 81.000,01 A R$ 360.000,00	EMPRESARIO INDIVIDUAL	ALTA	SERVICOS PROFISSIONAIS, TECNICOS E CIENTIFICOS	ACIMA DE 1 ANO	VERDE	2015-08-17	2874.04	1	1	0	0.0	1.0	1.0	1	1	1f9bcabc9d3173c1fe769899e4fac14b053037b953a1e4...	1 a 5	3.200000	NaN	NaN	NaN	OUTROS	SERVICOS DE ARQUITETURA E ENGENHARIA TESTES E ...	LESTE POTIGUAR	NATAL	ATIVIDADES PROFISSIONAIS CIENTIFICAS E TECNICAS	27.0	0	1.0	NaN	NaN	1.0	0.0	NaN	SERVIÇO	RN	RN	210000.0	210000.0
5	DE R$ 81.000,01 A R$ 360.000,00	DE R$ 81.000,01 A R$ 360.000,00	SOCIEDADE EMPRESARIA LIMITADA	ALTA	QUIMICA-PETROQUIMICA	ACIMA DE 1 ANO	LARANJA	2005-11-03	NaN	0	1	0	0.0	0.0	0.0	0	0	529a1f5fc6f88071db7d38492a0ce7c985c77e9b1c3bb6...	> 20	38.079452	NaN	NaN	NaN	ENTIDADES EMPRESARIAIS	FABRICACAO DE PRODUTOS DE MINERAIS NAO METALICOS	OESTE POTIGUAR	PAU DOS FERROS	INDUSTRIAS DE TRANSFORMACAO	48.0	0	NaN	NaN	NaN	NaN	NaN	NaN	INDUSTRIA	RN	RN	210000.0	210000.0
6	ATE R$ 81.000,00	ATE R$ 81.000,00	EMPRESARIO INDIVIDUAL	MEDIA	TRANSPORTE, ARMAZENAGEM E CORREIO	ACIMA DE 1 ANO	AMARELO	2011-07-21	NaN	1	1	1	1.0	1.0	1.0	1	0	8bf37c178778e537b108e58bf20552abe10c3a7fae129b...	5 a 10	7.276712	63.0	63.0	63.0	OUTROS	TRANSPORTE TERRESTRE	NORTE MARANHENSE	AGLOMERACAO URBANA DE SAO LUIS	TRANSPORTE ARMAZENAGEM E CORREIO	23.0	0	1.0	NaN	1.0	1.0	0.0	1.0	SERVIÇO	MA	MA	50000.0	50000.0
7	NaN	NaN	EMPRESARIO INDIVIDUAL	ALTA	SERVICOS ADMINISTRATIVOS	NaN	NaN	2018-10-09	NaN	1	1	1	NaN	NaN	1.0	1	1	0114fd3fbdc347c561843cde6aece12e8e53cb5d32c77d...	<= 1	0.052055	40.0	40.0	40.0	OUTROS	AGENCIAS DE VIAGENS OPERADORES TURISTICOS E SE...	LESTE POTIGUAR	NATAL	ATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEME...	NaN	0	1.0	1.0	NaN	1.0	0.0	1.0	SERVIÇO	RN	RN	NaN	NaN
8	DE R$ 81.000,01 A R$ 360.000,00	DE R$ 81.000,01 A R$ 360.000,00	COOPERATIVA	ALTA	BENS DE CONSUMO	ACIMA DE 1 ANO	AZUL	2006-07-27	247.88	0	1	0	0.0	1.0	1.0	0	1	6c45aabb849a760a3a7107c7a61262642f683feb8912a4...	10 a 15	12.263014	36.0	36.0	36.0	ENTIDADES EMPRESARIAIS	FABRICACAO DE PRODUTOS DIVERSOS	CENTRO AMAZONENSE	PARINTINS	INDUSTRIAS DE TRANSFORMACAO	24.0	0	2.0	NaN	1.0	2.0	0.0	1.0	INDUSTRIA	AM	AM	210000.0	210000.0
9	DE R$ 81.000,01 A R$ 360.000,00	DE R$ 360.000,01 A R$ 1.500.000,00	EMPRESARIO INDIVIDUAL	MEDIA	COMERCIO VAREJISTA	ACIMA DE 1 ANO	VERMELHO	2004-10-30	1042.85	0	0	0	0.0	0.0	0.0	0	0	2fcd678d71b04ccb77644fff57706bdc7fcfbbec6b1926...	15 a 20	17.942466	52.0	52.0	52.0	OUTROS	COMERCIO VAREJISTA	OESTE POTIGUAR	MOSSORO	COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ...	54.0	3	1.0	NaN	1.0	1.0	0.0	NaN	COMERCIO	RN	RN	210000.0	840000.0

Last rows

	de_faixa_faturamento_estimado	de_faixa_faturamento_estimado_grupo	de_natureza_juridica	de_nivel_atividade	de_ramo	de_saude_rescencia	de_saude_tributaria	dt_situacao	empsetorcensitariofaixarendapopulacao	fl_email	fl_matriz	fl_mei	fl_optante_simei	fl_optante_simples	fl_passivel_iss	fl_rm	fl_telefone	fl_veiculo	id	idade_emp_cat	idade_empresa_anos	idade_maxima_socios	idade_media_socios	idade_minima_socios	natureza_juridica_macro	nm_divisao	nm_meso_regiao	nm_micro_regiao	nm_segmento	nu_meses_rescencia	qt_socios	qt_socios_feminino	qt_socios_masculino	qt_socios_pf	qt_socios_pj	qt_socios_st_regular	setor	sg_uf	sg_uf_matriz	vl_faturamento_estimado_aux	vl_faturamento_estimado_grupo_aux	vl_total_veiculos_leves_grupo
462288	DE R$ 81.000,01 A R$ 360.000,00	DE R$ 81.000,01 A R$ 360.000,00	EMPRESARIO INDIVIDUAL	MEDIA	COMERCIO VAREJISTA	ACIMA DE 1 ANO	AMARELO	2005-11-03	1135.64	0	1	0	0.0	1.0	0.0	0	0	0.0	25fc6c2f86ea82180b19935893969ca5943af053cf4fa6...	10 a 15	14.586301	NaN	NaN	NaN	OUTROS	COMERCIO VAREJISTA	SUDOESTE AMAZONENSE	JURUA	COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ...	22.0	1.0	NaN	NaN	1.0	0.0	NaN	COMERCIO	AM	AM	210000.0	210000.0	0.0
462289	DE R$ 81.000,01 A R$ 360.000,00	DE R$ 81.000,01 A R$ 360.000,00	EMPRESARIO INDIVIDUAL	BAIXA	TEXTEIS	SEM INFORMACAO	CINZA	2018-02-19	1387.18	1	1	1	NaN	NaN	0.0	0	1	0.0	7217389b17042e97dd2b35899f375aabd40901c90f26b4...	<= 1	0.687671	22.0	22.000000	22.0	OUTROS	FABRICACAO DE PRODUTOS TEXTEIS	NaN	NaN	INDUSTRIAS DE TRANSFORMACAO	NaN	1.0	1.0	NaN	1.0	0.0	1.0	INDUSTRIA	RO	RO	210000.0	210000.0	0.0
462290	DE R$ 81.000,01 A R$ 360.000,00	DE R$ 81.000,01 A R$ 360.000,00	SOCIEDADE EMPRESARIA LIMITADA	BAIXA	SERVICOS ADMINISTRATIVOS	ACIMA DE 1 ANO	AZUL	2009-08-04	NaN	0	1	0	0.0	1.0	1.0	1	1	0.0	6d1d4e188e3314878b59649c4f840e0ca141a3c03d5bfc...	5 a 10	9.238356	27.0	27.000000	27.0	ENTIDADES EMPRESARIAIS	SERVICOS DE ESCRITORIO DE APOIO ADMINISTRATIVO...	OESTE MARANHENSE	IMPERATRIZ	ATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEME...	21.0	2.0	1.0	NaN	2.0	0.0	1.0	SERVIÇO	MA	MA	210000.0	210000.0	0.0
462291	DE R$ 81.000,01 A R$ 360.000,00	DE R$ 81.000,01 A R$ 360.000,00	EMPRESARIO INDIVIDUAL	ALTA	SERVICOS DIVERSOS	ACIMA DE 1 ANO	AZUL	2006-02-07	6022.81	1	1	0	0.0	1.0	1.0	1	0	1.0	916d935f687e32f7c3efb21e982d908074d74eecf7ef4a...	10 a 15	12.728767	44.0	44.000000	44.0	OUTROS	OUTRAS ATIVIDADES DE SERVICOS PESSOAIS	CENTRO NORTE PIAUIENSE	TERESINA	OUTRAS ATIVIDADES DE SERVICOS	22.0	1.0	1.0	NaN	1.0	0.0	1.0	SERVIÇO	PI	PI	123638.4	123638.4	1.0
462292	DE R$ 81.000,01 A R$ 360.000,00	DE R$ 81.000,01 A R$ 360.000,00	ENTIDADE SINDICAL	BAIXA	SERVICOS DIVERSOS	ACIMA DE 1 ANO	AZUL	2001-12-26	1286.04	0	1	0	0.0	0.0	1.0	0	0	1.0	a29ac8a2e3a0bd8b806a7d62d135c806de7004dc088485...	15 a 20	16.849315	NaN	NaN	NaN	ENTIDADES SEM FINS LUCRATIVOS	ATIVIDADES DE ORGANIZACOES ASSOCIATIVAS	NaN	NaN	OUTRAS ATIVIDADES DE SERVICOS	23.0	NaN	NaN	NaN	NaN	NaN	NaN	SERVIÇO	RO	RO	210000.0	210000.0	1.0
462293	ATE R$ 81.000,00	ATE R$ 81.000,00	EMPRESARIO INDIVIDUAL	ALTA	COMERCIO E REPARACAO DE VEICULOS	ACIMA DE 1 ANO	VERDE	2015-07-28	585.63	1	1	1	1.0	1.0	0.0	0	1	0.0	469ee5fc984d0bb60aa2f40cda4d003d7c9b963d149ed3...	1 a 5	3.254795	31.0	31.000000	31.0	OUTROS	COMERCIO E REPARACAO DE VEICULOS AUTOMOTORES E...	AGRESTE POTIGUAR	BORBOREMA POTIGUAR	COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ...	22.0	1.0	NaN	1.0	1.0	0.0	1.0	COMERCIO	RN	RN	50000.0	50000.0	0.0
462294	DE R$ 81.000,01 A R$ 360.000,00	DE R$ 81.000,01 A R$ 360.000,00	EMPRESARIO INDIVIDUAL	MUITO BAIXA	SERVICOS ADMINISTRATIVOS	ACIMA DE 1 ANO	LARANJA	2009-11-16	2429.89	0	1	0	0.0	0.0	1.0	1	0	0.0	656f496e7e2fad708f0022d8ad97d2cb9344e839a5f3cb...	5 a 10	8.953425	NaN	NaN	NaN	OUTROS	SELECAO AGENCIAMENTO E LOCACAO DE MAO DE OBRA	CENTRO NORTE PIAUIENSE	TERESINA	ATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEME...	23.0	NaN	NaN	NaN	NaN	NaN	NaN	SERVIÇO	PI	PI	210000.0	210000.0	0.0
462295	DE R$ 81.000,01 A R$ 360.000,00	DE R$ 81.000,01 A R$ 360.000,00	ASSOCIACAO PRIVADA	MEDIA	SERVICOS DE SAUDE	ACIMA DE 1 ANO	AMARELO	2005-11-03	3150.81	0	1	0	0.0	0.0	1.0	1	0	0.0	9b933a5cf2149d1338f00fb459d34a16b9b0f2e8d3e8e1...	> 20	20.745205	74.0	74.000000	74.0	ENTIDADES SEM FINS LUCRATIVOS	ATIVIDADES DE ATENCAO A SAUDE HUMANA	NORTE MARANHENSE	AGLOMERACAO URBANA DE SAO LUIS	SAUDE HUMANA E SERVICOS SOCIAIS	23.0	1.0	NaN	1.0	1.0	0.0	1.0	SERVIÇO	MA	MA	210000.0	210000.0	0.0
462296	DE R$ 360.000,01 A R$ 1.500.000,00	DE R$ 360.000,01 A R$ 1.500.000,00	SOCIEDADE EMPRESARIA LIMITADA	ALTA	COMERCIO VAREJISTA	ACIMA DE 1 ANO	VERDE	2016-11-30	2752.49	1	1	0	0.0	0.0	0.0	0	0	0.0	84db0f17467cf4f02439e01ade57150b6ac59d9dae53ed...	1 a 5	1.909589	39.0	31.666667	25.0	ENTIDADES EMPRESARIAIS	COMERCIO VAREJISTA	NaN	NaN	COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ...	20.0	5.0	1.0	2.0	5.0	0.0	3.0	COMERCIO	RO	RO	432734.4	432734.4	0.0
462297	DE R$ 81.000,01 A R$ 360.000,00	DE R$ 81.000,01 A R$ 360.000,00	EMPRESARIO INDIVIDUAL	BAIXA	TRANSPORTE, ARMAZENAGEM E CORREIO	SEM INFORMACAO	CINZA	2018-01-10	NaN	1	1	1	NaN	NaN	1.0	0	1	0.0	3d43e934e150b86be1e67524f5ba1018b27da9ef25566d...	<= 1	0.797260	44.0	44.000000	44.0	OUTROS	CORREIO E OUTRAS ATIVIDADES DE ENTREGA	NaN	NaN	TRANSPORTE ARMAZENAGEM E CORREIO	NaN	1.0	NaN	1.0	1.0	0.0	1.0	SERVIÇO	RO	RO	210000.0	210000.0	0.0

Overview

Variables

Correlations

Missing values

Sample

First rows

Last rows